Film_Locations_in_San_Francisco

Data source: data.sfgov.org

45 rows where Release Year = 7

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Fun Facts, Production Company, Distributor, Director, Writer, Actor 1, Actor 2, Actor 3

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
16 16 A Night Full of Rain 7 1978 7 Embarcadero Freeway Embarcadero Freeway, which was featured in the film was demolished in 1989 because of structural damage from the 1989 Loma Prieta Earthquake) Liberty Film 7 Warner Bros. Pictures 6 Lina Wertmuller 7 Lina Wertmuller 6 Candice Bergen 242 Giancarlo Gianni 6  
17 17 A Night Full of Rain 7 1978 7 Fairmont Hotel (950 Mason Street, Nob Hill) In 1945 the Fairmont hosted the United Nations Conference on International Organization as delegates arrived to draft a charter for the organization. The U.S. Secretary of State, Edward Stettinius drafted the charter in the hotel's Garden Room. Liberty Film 7 Warner Bros. Pictures 6 Lina Wertmuller 7 Lina Wertmuller 6 Candice Bergen 242 Giancarlo Gianni 6  
18 18 A Night Full of Rain 7 1978 7 San Francisco Chronicle (901 Mission Street at 15th Street) The San Francisco Zodiac Killer of the late 1960s sent his notes and letters to the Chronicle's offices. Liberty Film 7 Warner Bros. Pictures 6 Lina Wertmuller 7 Lina Wertmuller 6 Candice Bergen 242 Giancarlo Gianni 6  
19 19 A Night Full of Rain 7 1978 7 Broadway (North Beach)   Liberty Film 7 Warner Bros. Pictures 6 Lina Wertmuller 7 Lina Wertmuller 6 Candice Bergen 242 Giancarlo Gianni 6  
89 89 Attack of the Killer Tomatoes 23 1978 7 Hyde Street Cable Car SF Cable Cars are the only moving National Historical Landmark. Four Square Productions 20 NAI Entertainment 16 John DeBello 21 John DeBello 20 David Miller 256    
324 324 Faces of Death 58 1978 7     F.O.D Productions 44 Aquarius Releasing 35 Conan Le Cilaire 53 Alan Black 54 Michael Carr 281    
522 522 Foul Play 99 1978 7 War Memorial Opera House (401 Van Ness Avenue) In 1945 the United Nations had its first conference at The War Memorial Opera House. Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
523 523 Foul Play 99 1978 7 Sutter & Buchannan Streets   Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
524 524 Foul Play 99 1978 7 Sutter & Baker Streets   Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
525 525 Foul Play 99 1978 7 Sokoji-Soto Zen Buddhist Temple (1691 Laguna Street)   Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
526 526 Foul Play 99 1978 7 Sacramento & Hyde Streets (Nob Hill)   Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
527 527 Foul Play 99 1978 7 Postcard Row (Alamo Square, Hayes Valley) The 6 Victorian homes across from Alamo Square Park are among the few Victorians to survive the Great Fire. Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
528 528 Foul Play 99 1978 7 Potrero Hill Bathhouse & Feed Co. (199 Mississippi Street)   Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
529 529 Foul Play 99 1978 7 Octavia & Hayes Streets (Hayes Valley)   Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
530 530 Foul Play 99 1978 7 Montgomery & Pine Streets (Financial District)   Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
531 531 Foul Play 99 1978 7 Laguna & Sacramento Streets (Pacific Heights)   Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
532 532 Foul Play 99 1978 7 Hayes Valley Care (601 Laguna Street, Hayes Valley)   Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
533 533 Foul Play 99 1978 7 Golden Gate & Steiner Streets (Hayes Valley)   Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
534 534 Foul Play 99 1978 7 Fort Point, Presidio Built in 1853, Fort Point is the only West Coast fort built by the Union Army. Though the Confederate army planned to attack San Francisco, the commanding Confederate general learned that the war had ended while end route to SF. Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
535 535 Foul Play 99 1978 7 Fort Mason (Golden Gate National Recreation Area) Constructed in 1864 as a coastal defense site, Fort Mason went on to serve as an army post for more than 100 years. Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
536 536 Foul Play 99 1978 7 Flood Building (870 Market Street)   Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
537 537 Foul Play 99 1978 7 Fiesta Laundromat (898 S. Van Ness Ave., Mission)   Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
538 538 Foul Play 99 1978 7 City Hall The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building. Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
539 539 Foul Play 99 1978 7 California & Larkin Streets (Nob Hill)   Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
540 540 Foul Play 99 1978 7 Asian Art Museum (200 Larkin Street, Civic Center) The Dalai Lama opened an exhibition on Wisdom and Compassion at the museum in 1991. Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
541 541 Foul Play 99 1978 7 Andrew S. Hallidie Plaza (Market & Powell Streets)   Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
542 542 Foul Play 99 1978 7 430 Vallejo Street (Telegraph Hill)   Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
543 543 Foul Play 99 1978 7 24th and Castro Streets (Noe Valley)   Paramount Pictures 4 Paramount Pictures 3 Colin Higgins 90 Colin Higgins 91 Goldie Hawn 306 Chevy Chase 79 Burgess Meredith 477
684 684 Invasion of the Body Snatchers 134 1978 7 Pier 33 (Embarcadero)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
686 686 Invasion of the Body Snatchers 134 1978 7 Department of Public Health (101 Grove Street at Polk, Civic Center)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
687 687 Invasion of the Body Snatchers 134 1978 7 United Nations Plaza (Civic Center) United Nations Plaza was built in 1975 and across its walkways are white lines into which the preamble to the preamble of the UN charter is carved. Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
688 688 Invasion of the Body Snatchers 134 1978 7 Transamerica Building (600 Montgomery Street at Clay) The Pyramid was the tallest skyscraper west of the Mississippi from 1972-1974, until it was surpassed by Los Angeles' Aon Center. Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
689 689 Invasion of the Body Snatchers 134 1978 7 San Francisco Drydock (20th and Illinois Streets)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
690 690 Invasion of the Body Snatchers 134 1978 7 Ramada Plaza Hotel Downtown (1231 Market Street, Civic Center)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
691 691 Invasion of the Body Snatchers 134 1978 7 Postcard Row (Alamo Square, Hayes Valley) The 6 Victorian homes across from Alamo Square Park are among the few Victorians to survive the Great Fire. Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
692 692 Invasion of the Body Snatchers 134 1978 7 Lafayette Park (Pacific Heights)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
693 693 Invasion of the Body Snatchers 134 1978 7 Hamlin Hotel (385 Eddy Street)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
694 694 Invasion of the Body Snatchers 134 1978 7 City Hall The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building. Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
695 695 Invasion of the Body Snatchers 134 1978 7 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
696 696 Invasion of the Body Snatchers 134 1978 7 Broadway Tunnel (Russian Hill)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
697 697 Invasion of the Body Snatchers 134 1978 7 Bimbo's 365 Club (1025 Columbus Avenue, North Beach)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
698 698 Invasion of the Body Snatchers 134 1978 7 720 Steiner Street (Hayes Valley)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
699 699 Invasion of the Body Snatchers 134 1978 7 32 Napier Lane   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
700 700 Invasion of the Body Snatchers 134 1978 7 1227 Montgomery Street (Telegraph Hill)   Solofilm 89 United Artists 19 Philip Kaufman 111 Jack Finney 124 Donald Sutherland 286 Jeff Goldblum 110 Brooke Adams 491
1269 1269 Superman 233 1978 7 Golden Gate Bridge With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937. Dovemead Films 142 Warner Bros. Pictures 6 Richard Donner 192 Jerry Siegel 203 Christopher Reeve 389 Gene Hackman 178 Marlon Brando 524

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Film_Locations_in_San_Francisco" (
"Title" INTEGER,
  "Release Year" INTEGER,
  "Locations" TEXT,
  "Fun Facts" REAL,
  "Production Company" INTEGER,
  "Distributor" INTEGER,
  "Director" INTEGER,
  "Writer" INTEGER,
  "Actor 1" INTEGER,
  "Actor 2" INTEGER,
  "Actor 3" INTEGER
,
FOREIGN KEY ("Title") REFERENCES [Title](id),
    FOREIGN KEY ("Director") REFERENCES [Director](id),
    FOREIGN KEY ("Actor 2") REFERENCES [Actors](id),
    FOREIGN KEY ("Actor 1") REFERENCES [Actors](id),
    FOREIGN KEY ("Writer") REFERENCES [Writer](id),
    FOREIGN KEY ("Release Year") REFERENCES [Release Year](id),
    FOREIGN KEY ("Actor 3") REFERENCES [Actors](id),
    FOREIGN KEY ("Production Company") REFERENCES [Production Company](id),
    FOREIGN KEY ("Distributor") REFERENCES [Distributor](id));
CREATE INDEX ["Film_Locations_in_San_Francisco_Title"] ON [Film_Locations_in_San_Francisco]("Title");
CREATE INDEX ["Film_Locations_in_San_Francisco_Director"] ON [Film_Locations_in_San_Francisco]("Director");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 2"] ON [Film_Locations_in_San_Francisco]("Actor 2");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 1"] ON [Film_Locations_in_San_Francisco]("Actor 1");
CREATE INDEX ["Film_Locations_in_San_Francisco_Writer"] ON [Film_Locations_in_San_Francisco]("Writer");
CREATE INDEX ["Film_Locations_in_San_Francisco_Release Year"] ON [Film_Locations_in_San_Francisco]("Release Year");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 3"] ON [Film_Locations_in_San_Francisco]("Actor 3");
CREATE INDEX ["Film_Locations_in_San_Francisco_Production Company"] ON [Film_Locations_in_San_Francisco]("Production Company");
CREATE INDEX ["Film_Locations_in_San_Francisco_Distributor"] ON [Film_Locations_in_San_Francisco]("Distributor");
Powered by Datasette · Query took 36.1ms · Data source: data.sfgov.org